FaNSLDSWork05

Logical Entity Name | FaNSLDSWork05
Default Table Name | FaNSLDSWork05
Physical Only | NO
Owner | dbo
Definition |
Note |

FaNSLDSWork05 Columns

ColumnName | Domain | Datatype | NULL | Definition
FaNSLDSWork05ID |  | int | NO |
FaISIR05ID |  | int | YES |
Name |  | char(60) | YES |
SSN |  | char(17) | YES |
TransactionProcessed |  | datetime | YES |
OverPaymentChangeFlag |  | char(1) | YES |
DefaultChangeFlag |  | char(1) | YES |
DefaultedLoanFlag |  | char(1) | YES |
DischargedChangeFlag |  | char(1) | YES |
DischargedLoanFlag |  | char(1) | YES |
SatRepayChangeFlag |  | char(1) | YES |
LoanSatRepayFlag |  | char(1) | YES |
ActiveBankruptChangeFlag |  | char(1) | YES |
ActiveBankruptcyFlag |  | char(1) | YES |
PellOverPayFlag |  | char(1) | YES |
PellOverPayContact |  | char(12) | YES |
SEOGOverpayFlag |  | char(1) | YES |
SEOGOverpayContact |  | char(12) | YES |
PerkinsOverpayFlag |  | char(1) | YES |
PerkinsOverpayContact |  | char(12) | YES |
AggrSubsidizedBal |  | char(8) | YES |
AggrSubsidizedDisbPending |  | char(8) | YES |
AggrSubsidizedTotal |  | char(8) | YES |
AggrCombinedBal |  | char(8) | YES |
AggrCombinedDisbPending |  | char(8) | YES |
AggrCombinedTotal |  | char(8) | YES |
AggrConsolidateBal |  | char(8) | YES |
AggrConsolidatedTotal |  | char(8) | YES |
PerkinsLoanChangeFlag |  | char(1) | YES |
PerkinsPrinBalance |  | char(8) | YES |
PerkinsCurrYrLoanAmount |  | char(8) | YES |
PerkinsFirstDisbPrior |  | char(1) | YES |
PellPaymentChangeFlag |  | char(1) | YES |
AdditionalPellFlag |  | char(1) | YES |
PellSchoolCode1 |  | char(8) | YES |
PellSchoolCode2 |  | char(8) | YES |
PellSchoolCode3 |  | char(8) | YES |
TransactionNumber1 |  | char(2) | YES |
TransactionNumber2 |  | char(2) | YES |
TransactionNumber3 |  | char(2) | YES |
ScheduledAmount1 |  | char(7) | YES |
ScheduledAmount2 |  | char(7) | YES |
ScheduledAmount3 |  | char(7) | YES |
PellAwardAmt1 |  | char(7) | YES |
PellAwardAmt2 |  | char(7) | YES |
PellAwardAmt3 |  | char(7) | YES |
AmountPaidToDate1 |  | char(7) | YES |
AmountPaidToDate2 |  | char(7) | YES |
AmountPaidToDate3 |  | char(7) | YES |
PercentAwardUsed1 |  | char(6) | YES |
PercentAwardUsed2 |  | char(6) | YES |
PercentAwardUsed3 |  | char(6) | YES |
LastUpdateDate1 |  | char(10) | YES |
LastUpdateDate2 |  | char(10) | YES |
LastUpdateDate3 |  | char(10) | YES |
VerificationFlag1 |  | char(3) | YES |
VerificationFlag2 |  | char(3) | YES |
VerificationFlag3 |  | char(3) | YES |
EFC1 |  | char(6) | YES |
EFC2 |  | char(6) | YES |
EFC3 |  | char(6) | YES |
ChangeFlag1 |  | char(1) | YES |
ChangeFlag2 |  | char(1) | YES |
ChangeFlag3 |  | char(1) | YES |
ChangeFlag4 |  | char(1) | YES |
ChangeFlag5 |  | char(1) | YES |
ChangeFlag6 |  | char(1) | YES |
ProgramCode1 |  | char(30) | YES |
ProgramCode2 |  | char(30) | YES |
ProgramCode3 |  | char(30) | YES |
ProgramCode4 |  | char(30) | YES |
ProgramCode5 |  | char(30) | YES |
ProgramCode6 |  | char(30) | YES |
NetAmount1 |  | char(8) | YES |
NetAmount2 |  | char(8) | YES |
NetAmount3 |  | char(8) | YES |
NetAmount4 |  | char(8) | YES |
NetAmount5 |  | char(8) | YES |
NetAmount6 |  | char(8) | YES |
LoanBeginDate1 |  | char(10) | YES |
LoanBeginDate2 |  | char(10) | YES |
LoanBeginDate3 |  | char(10) | YES |
LoanBeginDate4 |  | char(10) | YES |
LoanBeginDate5 |  | char(10) | YES |
LoanBeginDate6 |  | char(10) | YES |
LoanEndDate1 |  | char(10) | YES |
LoanEndDate2 |  | char(10) | YES |
LoanEndDate3 |  | char(10) | YES |
LoanEndDate4 |  | char(10) | YES |
LoanEndDate5 |  | char(10) | YES |
LoanEndDate6 |  | char(10) | YES |
GaCode1 |  | char(3) | YES |
GaCode2 |  | char(3) | YES |
GaCode3 |  | char(3) | YES |
GaCode4 |  | char(3) | YES |
GaCode5 |  | char(3) | YES |
GaCode6 |  | char(3) | YES |
LoanSchoolCode1 |  | char(8) | YES |
LoanSchoolCode2 |  | char(8) | YES |
LoanSchoolCode3 |  | char(8) | YES |
LoanSchoolCode4 |  | char(8) | YES |
LoanSchoolCode5 |  | char(8) | YES |
LoanSchoolCode6 |  | char(8) | YES |
GradeLevel1 |  | char(3) | YES |
GradeLevel2 |  | char(3) | YES |
GradeLevel3 |  | char(3) | YES |
GradeLevel4 |  | char(3) | YES |
GradeLevel5 |  | char(3) | YES |
GradeLevel6 |  | char(3) | YES |
LoanContactCode1 |  | char(8) | YES |
LoanContactCode2 |  | char(8) | YES |
LoanContactCode3 |  | char(8) | YES |
LoanContactCode4 |  | char(8) | YES |
LoanContactCode5 |  | char(8) | YES |
LoanContactCode6 |  | char(8) | YES |
CurrentStatusCode1 |  | char(2) | YES |
CurrentStatusCode2 |  | char(2) | YES |
CurrentStatusCode3 |  | char(2) | YES |
CurrentStatusCode4 |  | char(2) | YES |
CurrentStatusCode5 |  | char(2) | YES |
CurrentStatusCode6 |  | char(2) | YES |
CurrentStatusDate1 |  | char(10) | YES |
CurrentStatusDate2 |  | char(10) | YES |
CurrentStatusDate3 |  | char(10) | YES |
CurrentStatusDate4 |  | char(10) | YES |
CurrentStatusDate5 |  | char(10) | YES |
CurrentStatusDate6 |  | char(10) | YES |
OutPrincipalBalance1 |  | char(8) | YES |
OutPrincipalBalance2 |  | char(8) | YES |
OutPrincipalBalance3 |  | char(8) | YES |
OutPrincipalBalance4 |  | char(8) | YES |
OutPrincipalBalance5 |  | char(8) | YES |
OutPrincipalBalance6 |  | char(8) | YES |
OutPrincipalBalanceDate1 |  | char(10) | YES |
OutPrincipalBalanceDate2 |  | char(10) | YES |
OutPrincipalBalanceDate3 |  | char(10) | YES |
OutPrincipalBalanceDate4 |  | char(10) | YES |
OutPrincipalBalanceDate5 |  | char(10) | YES |
OutPrincipalBalanceDate6 |  | char(10) | YES |
LoanContactType1 |  | char(3) | YES |
LoanContactType2 |  | char(3) | YES |
LoanContactType3 |  | char(3) | YES |
LoanContactType4 |  | char(3) | YES |
LoanContactType5 |  | char(3) | YES |
LoanContactType6 |  | char(3) | YES |
ExtraUnsubLoan1 |  | char(20) | YES |
ExtraUnsubLoan2 |  | char(20) | YES |
ExtraUnsubLoan3 |  | char(20) | YES |
ExtraUnsubLoan4 |  | char(20) | YES |
ExtraUnsubLoan5 |  | char(20) | YES |
ExtraUnsubLoan6 |  | char(20) | YES |
CapitalizedInterestFlag1 |  | char(3) | YES |
CapitalizedInterestFlag2 |  | char(3) | YES |
CapitalizedInterestFlag3 |  | char(3) | YES |
CapitalizedInterestFlag4 |  | char(3) | YES |
CapitalizedInterestFlag5 |  | char(3) | YES |
CapitalizedInterestFlag6 |  | char(3) | YES |
AdditionalLoansFlag |  | char(1) | YES |
AggrLoanChangeFlag |  | char(1) | YES |
DLPromNote |  | char(20) | YES |
DLPlusPromNote |  | char(20) | YES |
FFELPromNote |  | char(1) | YES |
FFELLenderCode |  | char(6) | YES |
SubsidizedLoanLimitFlag |  | char(15) | YES |
CombinedLoanLimitFlag |  | char(15) | YES |
NSLDSPostReasonCode |  | char(8) | YES |
AggrUnSubBal |  | char(8) | YES |
AggrUnSubsidizedDisb |  | char(8) | YES |
AggrUnsubTotal |  | char(8) | YES |
LoanTypeCode1 |  | char(10) | YES |
LoanTypeCode2 |  | char(10) | YES |
LoanTypeCode3 |  | char(10) | YES |
LoanTypeCode4 |  | char(10) | YES |
LoanTypeCode5 |  | char(10) | YES |
LoanTypeCode6 |  | char(10) | YES |
AmtofLastDisb1 |  | char(8) | YES |
AmtofLastDisb2 |  | char(8) | YES |
AmtofLastDisb3 |  | char(8) | YES |
AmtofLastDisb4 |  | char(8) | YES |
AmtofLastDisb5 |  | char(8) | YES |
AmtofLastDisb6 |  | char(8) | YES |
DateofLastDisb1 |  | char(10) | YES |
DateofLastDisb2 |  | char(10) | YES |
DateofLastDisb3 |  | char(10) | YES |
DateofLastDisb4 |  | char(10) | YES |
DateofLastDisb5 |  | char(10) | YES |
DateofLastDisb6 |  | char(10) | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |

FaNSLDSWork05 Primary and Unique Keys

Key Name | Key Type | Keys
FaNSLDSWork05_FaNSLDSWork05ID_U_C_IDX | PrimaryKey | FaNSLDSWork05ID

FaNSLDSWork05 Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
FaISIR05 | Non-Identifying | Zero or One to Zero or More | FK_FaNSLDSWork05_FaISIR05ID_FaISIR05_FaISIR05ID |  |  | FaISIR05ID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_FaNSLDSWork05_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaNSLDSWork05 Check Constraints

Check Constraint Name | CheckConstraint

FaNSLDSWork05 Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaNSLDSWork05 Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaNSLDSWork05 | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaNSLDSWork05 | NO |  |  |

FaNSLDSWork05 Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaNSLDSWork05 Data Movement Rules

Name | Type | Rule Text/Value